100
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the control.
FUNCTION pivotEvents_Click()
	_ObjectCallMethod( pivot , "ClearFilter");
END

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
ObjectAssociateEvents("pivotEvents", pivot);
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "FilterBarPromptVisible", 1);
_ObjectSetProperty( pivot , "FilterBarPromptPattern", "USA");
_ObjectCallMethod( pivot , "EndUpdate");
99
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "FilterBarPromptPattern", "USA");
_ObjectSetProperty( pivot , "FilterBarPromptVisible", 3);
_ObjectCallMethod( pivot , "EndUpdate");
98
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "FilterBarPromptVisible", 1);
_ObjectSetProperty( pivot , "FilterBarPromptPattern", "USA");
_ObjectCallMethod( pivot , "EndUpdate");
97
Is it possible to prevent closing the control's filter bar, so it is always shown

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "FilterBarCaption", "len(value) = 0 ? `<fgcolor=808080>no filter` : value");
_ObjectSetProperty( pivot , "FilterBarPromptVisible", 2);
_ObjectCallMethod( pivot , "EndUpdate");
96
How can I find if the control is running in DPI mode
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
Message( _ObjectCallMethod( pivot , "FormatABC", "dpi = 1 ? `normal/stretch mode` : `dpi mode`") );
95
If I connect it to a datasource, all works perfectly but the records that I see in the control is a little number of total of the recordset. I need to show all 60.000 rows of the recordset without click on the [...] button. It s possible to setting up this parameters
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectSetProperty( pivot , "DisplayPivotData", -1);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
94
How do I change the drop down filter icon/button (white)

OBJECT appearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
appearance = _ObjectGetProperty( pivot , "VisualAppearance");
	_ObjectCallMethod( appearance , "Add", 2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN" +
	"J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" +
	"NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" +
	"hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" +
	"bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" +
	"BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=");
	_ObjectCallMethod( appearance , "Add", 1,"CP:2 -6 -4 2 4");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Background(0) = 16777216");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Background(32) = BackColor");
_ObjectSetProperty( pivot , "HeaderVisible", -1);
_ObjectSetProperty( pivot , "HeaderHeight", 24);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "DisplayFilterList", 288);
_ObjectSetProperty( pivot , "PivotBarVisible", 1);
_ObjectCallMethod( pivot , "EndUpdate");
93
How do I change the drop down filter icon/button (black)

OBJECT appearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
appearance = _ObjectGetProperty( pivot , "VisualAppearance");
	_ObjectCallMethod( appearance , "Add", 1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQ" +
	"gmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYTh" +
	"dr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Background(0) = 16777216");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Background(32) = -1");
_ObjectSetProperty( pivot , "BackColorHeader", 0);
_ObjectSetProperty( pivot , "ForeColorHeader", 16777215);
_ObjectSetProperty( pivot , "HeaderVisible", -1);
_ObjectSetProperty( pivot , "HeaderHeight", 22);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "DisplayFilterList", 288);
_ObjectCallMethod( pivot , "EndUpdate");
92
How do I prevent showing the control's BackColorAlternate property on empty / non-items part of the control

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectSetProperty( pivot , "BackColorAlternate", 2146496752);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "12");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
_ObjectCallMethod( pivot , "EndUpdate");
91
How can I find out if the user clicks the grid's header
// MouseMove event - Occurs when the user moves the mouse.
FUNCTION pivotEvents_MouseMove(OBJECT pivot, INT Button, INT Shift, INT X, INT Y)
	Message( "Type of ColumnFromPoint: " );
	Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "ColumnFromPoint(-1,-1)") );
	Message( " should not be VT_NULL" );
	Message( "Type of ValueFromPoint: " );
	Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "ValueFromPoint(-1,-1)") );
	Message( " should be VT_NULL" );
END

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
ObjectAssociateEvents("pivotEvents", pivot);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
90
What should I set FormatPivotHeader to, to show it on the columns header only

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12");
_ObjectSetProperty( pivot , "FormatPivotHeader", "(iaggregate ? ( caption + ` <off -6><font ;6>(` + lower(caggregate) + ')</off></font>') : caption) + ( ( display=1 ? `<c>Date: " +
	"<b><upline><dotline>` + date(`now`) : `` ) + `</dotline> </b>` )");
_ObjectCallMethod( pivot , "EndUpdate");
89
What should I set FormatPivotHeader to, to show "Report Generated on 7/9/2016 14:20" etc when the report is executed (ie the date and time will change)

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12");
_ObjectSetProperty( pivot , "FormatPivotHeader", "(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + ')</off></font>') : caption) + `<r>ReportDate:" +
	" ` + date(`now`)");
_ObjectCallMethod( pivot , "EndUpdate");
88
Is it possible to display aggregate result on parent rows as well

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectSetProperty( pivot , "HeaderHeight", 22);
_ObjectSetProperty( pivot , "DefaultItemHeight", 20);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "12[bold],0");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "nempty","not empty","");
	_ObjectSetProperty( formatconditionalappearance , "Expression", "len(value) != 0");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 15790320);
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[nempty]/6");
_ObjectSetProperty( pivot , "IncludeExpandColumn", 1);
_ObjectSetProperty( pivot , "DrawGridLines", 0);
_ObjectSetProperty( pivot , "ShowBranchRows", 33);
_ObjectCallMethod( pivot , "EndUpdate");
87
How do I show expanded/collapsed rows

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectSetProperty( pivot , "HeaderHeight", 22);
_ObjectSetProperty( pivot , "DefaultItemHeight", 20);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "12[bold],0");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "nempty","not empty","");
	_ObjectSetProperty( formatconditionalappearance , "Expression", "len(value) != 0");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 15790320);
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[nempty]/6");
_ObjectSetProperty( pivot , "IncludeExpandColumn", 1);
_ObjectSetProperty( pivot , "DrawGridLines", 0);
_ObjectCallMethod( pivot , "EndUpdate");
86
How do I show expanded/collapsed columns

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectSetProperty( pivot , "HeaderHeight", 22);
_ObjectSetProperty( pivot , "DefaultItemHeight", 20);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "nempty","not empty","");
	_ObjectSetProperty( formatconditionalappearance , "Expression", "len(value) != 0");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 15790320);
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[nempty]/12");
_ObjectSetProperty( pivot , "FormatPivotHeader", "(iaggregate ? ( caption + ` <r>[` + lower(caggregate) + `]` ) : caption)");
_ObjectSetProperty( pivot , "IncludeExpandColumn", 1);
_ObjectCallMethod( pivot , "EndUpdate");
85
Where you have say "Sum of ...." as the first row heading of the pivot are there and options to be able to change this text as a whole

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "nempty","not empty","");
	_ObjectSetProperty( formatconditionalappearance , "Expression", "len(value) != 0");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 15790320);
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[nempty]/12");
_ObjectSetProperty( pivot , "FormatPivotHeader", "(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + ' )') : caption)");
_ObjectCallMethod( pivot , "EndUpdate");
84
How can I get the data column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
FUNCTION pivotEvents_MouseMove(OBJECT pivot, INT Button, INT Shift, INT X, INT Y)
	Message( "DataColumn" );
	Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumnFromPoint(-1,-1)") );
END

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
ObjectAssociateEvents("pivotEvents", pivot);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric]");
_ObjectCallMethod( pivot , "Refresh");
83
Is there any way for the user to change the alignment at runtime (using excontextmenu)

// RClick event - Occurs once the user right clicks the control.
FUNCTION pivotEvents_RClick()
	OBJECT c,column;
	_ObjectCallMethod(pivot, "TemplatePut", "Dim _ObObj")
	_ObjectCallMethod(pivot, "TemplatePut", _ObjectGetProperty( pivot , "DataColumns"))
	h = _ObjectCallMethod(pivot, "ExecuteTemplate", "_ObObj.item(5).Alignment");
	c = CreateObject("Exontrol.ContextMenu");
		_ObjectSetProperty( c , "FlatImageWidth", 0);
		_ObjectSetProperty( c , "ToString", "Alignment[align=1][dis],[group=0x71](Left[typ=2][grp=100][close=0][id=0],Center[typ=2][grp=100][close=0][id=1],Right[typ=2][grp" +
		"=100][close=0][id=2])");
		_ObjectCallMethod(pivot, "TemplatePut", "Dim cObj,h")
		_ObjectCallMethod(pivot, "TemplatePut", c)
		_ObjectCallMethod(pivot, "TemplatePut", h)
		_ObjectCallMethod(pivot, "ExecuteTemplate", "cObj.item(h).Checked = True");
		h = _ObjectCallMethod( c , "Select", );
	column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(5)");
		_ObjectSetProperty( column , "Alignment", h);
		_ObjectSetProperty( column , "HeaderAlignment", h);
	_ObjectCallMethod( pivot , "Refresh");
END

OBJECT column,pivot;

pivot =  ObjectByName("AN1") ;
ObjectAssociateEvents("pivotEvents", pivot);
_ObjectSetProperty( pivot , "PivotBarVisible", 3609);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(5)");
	_ObjectSetProperty( column , "Alignment", 2);
	_ObjectSetProperty( column , "HeaderAlignment", 2);
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric]");
_ObjectCallMethod( pivot , "Refresh");
82
Is there any way for the user to change the alignment at runtime

// RClick event - Occurs once the user right clicks the control.
FUNCTION pivotEvents_RClick()
	OBJECT column;
	Message( "The column gets aligned to the center" );
	column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(5)");
		_ObjectSetProperty( column , "Alignment", 1);
		_ObjectSetProperty( column , "HeaderAlignment", 1);
	_ObjectCallMethod( pivot , "Refresh");
END

OBJECT column,pivot;

pivot =  ObjectByName("AN1") ;
ObjectAssociateEvents("pivotEvents", pivot);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(5)");
	_ObjectSetProperty( column , "Alignment", 2);
	_ObjectSetProperty( column , "HeaderAlignment", 2);
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric]");
_ObjectCallMethod( pivot , "Refresh");
81
How can I align a column to the right

OBJECT column,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(5)");
	_ObjectSetProperty( column , "Alignment", 2);
	_ObjectSetProperty( column , "HeaderAlignment", 2);
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric]");
_ObjectCallMethod( pivot , "Refresh");
80
How can I display the control's content on an single A3 paper size, when using PDF format
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( _ObjectGetProperty( pivot , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`positive`).BackColor = 16842496");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`negative`).BackColor = 16777471");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[positive,negative]/12");
_ObjectCallMethod( pivot , "ExpandAll");
var_CopyTo = _ObjectCallMethod(pivot, "ExecuteTemplate", "CopyTo(`C:\Temp\Preview.pdf|11.69 in x 16.53 in||single`)");
Message( "Look for C:\Temp\Preview.pd file." );
_ObjectCallMethod( pivot , "EndUpdate");
79
How can I display the control's content on an A3 paper size, when using PDF format
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( _ObjectGetProperty( pivot , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`positive`).BackColor = 16842496");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`negative`).BackColor = 16777471");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[positive,negative]/12");
_ObjectCallMethod( pivot , "ExpandAll");
var_CopyTo = _ObjectCallMethod(pivot, "ExecuteTemplate", "CopyTo(`C:\Temp\Preview.pdf|11.69 in x 16.53 in`)");
Message( "Look for C:\Temp\Preview.pd file." );
_ObjectCallMethod( pivot , "EndUpdate");
78
How can I export the control's content to a PDF document (method 1)
OBJECT createobject("exontrol.print"),pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( _ObjectGetProperty( pivot , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`positive`).BackColor = 16842496");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`negative`).BackColor = 16777471");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[positive,negative]/12");
_ObjectCallMethod( pivot , "ExpandAll");
_ObjectCallMethod( pivot , "EndUpdate");
createobject("exontrol.print") = CreateObject("Exontrol.Print");
	_ObjectSetProperty( createobject("exontrol.print") , "PrintExt", pivot);
	_ObjectCallMethod( createobject("exontrol.print") , "CopyTo", "c:/temp/xtest.pdf");
Message( "Look for C:\Temp\xtest.pdf file." );
_ObjectCallMethod( pivot , "EndUpdate");
77
How can I export the control's content to a PDF document (method 2)
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( _ObjectGetProperty( pivot , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`positive`).BackColor = 16842496");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`negative`).BackColor = 16777471");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[positive,negative]/12");
_ObjectCallMethod( pivot , "ExpandAll");
var_CopyTo = _ObjectCallMethod(pivot, "ExecuteTemplate", "CopyTo(`c:/temp/xtest.pdf`)");
Message( "Look for C:\Temp\xtest.pdf file." );
_ObjectCallMethod( pivot , "EndUpdate");
76
Does / could the control have a read-only mode by where I could load the data and layout and just use the control to display it and allow the user to scroll around it / print it but not change it 
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric]");
_ObjectSetProperty( pivot , "DisplayFilterList", 2);
_ObjectSetProperty( pivot , "PivotBarVisible", 268435977);
_ObjectCallMethod( pivot , "Refresh");
75
Is it possible to edit the conditional-expression at runtime

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "custom","custom","");
	_ObjectSetProperty( formatconditionalappearance , "Bold", -1);
	_ObjectSetProperty( formatconditionalappearance , "FontSize", 12);
	_ObjectSetProperty( formatconditionalappearance , "Expression", "value > 2000");
	_ObjectSetProperty( formatconditionalappearance , "ContextEditExpression", -1);
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[custom]/12");
_ObjectCallMethod( pivot , "EndUpdate");
74
How can I highlight values using EBN colors

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( _ObjectGetProperty( pivot , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`positive`).BackColor = 16842496");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`negative`).BackColor = 16777471");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[positive,negative]/12");
_ObjectCallMethod( pivot , "EndUpdate");
73
How do I mark not-empty values in the chart

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "nempty","not empty","");
	_ObjectSetProperty( formatconditionalappearance , "Expression", "len(value) != 0");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 15790320);
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[nempty]/12");
_ObjectCallMethod( pivot , "EndUpdate");
72
How can I highlight negative and positive values in the same chart

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[negative,positive]/12");
_ObjectCallMethod( pivot , "EndUpdate");
71
How can I highlight values that starts with a letter

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "f","starts with f","lower(value) startwith `f`");
	_ObjectSetProperty( formatconditionalappearance , "Expression", "lower(value) startwith `f`");
	_ObjectSetProperty( formatconditionalappearance , "Shadow", 1);
	_ObjectSetProperty( formatconditionalappearance , "ShadowOffset", 0);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0[f]");
_ObjectCallMethod( pivot , "EndUpdate");
70
How can I mark values greater than a value, 100 for instance

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
formatconditionalappearance = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatConditionalAppearances") , "Add", "greater100",">100","value > 100");
	_ObjectSetProperty( formatconditionalappearance , "Expression", "( dbl(value) != 0 ) ? (value > 100) : 0");
	_ObjectSetProperty( formatconditionalappearance , "ForeColor", 255);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[greater100,content=numeric]");
_ObjectCallMethod( pivot , "EndUpdate");
69
How can I remove the Conditional context-menu

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectSetProperty( pivot , "PivotBarVisible", 4059);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric]");
_ObjectCallMethod( pivot , "EndUpdate");
68
How do change the way the negative/positive numbers show when using conditional-format

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
formatconditionalappearance = _ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`negative`)");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 0);
	_ObjectSetProperty( formatconditionalappearance , "ForeColor", 8421504);
	_ObjectSetProperty( formatconditionalappearance , "FontSize", 8);
formatconditionalappearance = _ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`positive`)");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 0);
	_ObjectSetProperty( formatconditionalappearance , "ForeColor", 1);
	_ObjectSetProperty( formatconditionalappearance , "FontSize", 11);
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[negative,positive,content=numeric]");
_ObjectCallMethod( pivot , "EndUpdate");
67
How do I highlight the negative values with white color or black

OBJECT formatconditionalappearance,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
formatconditionalappearance = _ObjectCallMethod(pivot, "ExecuteTemplate", "FormatConditionalAppearances.item(`negative`)");
	_ObjectSetProperty( formatconditionalappearance , "BackColor", 1);
	_ObjectSetProperty( formatconditionalappearance , "ForeColor", 16777215);
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[negative,content=numeric]");
_ObjectCallMethod( pivot , "EndUpdate");
66
Does your control support conditional-format, so I can highlight certain values

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[negative,content=numeric]");
_ObjectCallMethod( pivot , "EndUpdate");
65
How do I add a computed column/field, like VAT for instance (method 2)

OBJECT aggregates,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
aggregates = _ObjectGetProperty( pivot , "Aggregates");
	_ObjectSetProperty( _ObjectCallMethod( aggregates , "Add", "vat19","sum","VAT 19%","VAT 19%") , "FormatValue", "value * 0.19");
	_ObjectSetProperty( _ObjectCallMethod( aggregates , "Add", "vat24","sum","VAT 24%","VAT 24%") , "FormatValue", "value * 0.24");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric],vat19(5)[bold,content=numeric],vat24(5)[bold,content=numeric]");
_ObjectCallMethod( pivot , "EndUpdate");
64
How do I add a computed column/field, like VAT for instance (method 1)

OBJECT formatcontent,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
formatcontent = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatContents") , "Add", "vat19","VAT 19%");
	_ObjectSetProperty( formatcontent , "Expression", "len(value) ? ((value * 1.19) format '') : ''");
formatcontent = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatContents") , "Add", "vat24","VAT 24%");
	_ObjectSetProperty( formatcontent , "Expression", "len(value) ? ((value * 1.24) format '') : ''");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[content=numeric],sum(5)[bold,content=vat19],sum(5)[bold,content=vat24]");
_ObjectCallMethod( pivot , "EndUpdate");
63
How can I hide some values for instance negative values

OBJECT formatcontent,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
formatcontent = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatContents") , "Add", "hiden","hide negative");
	_ObjectSetProperty( formatcontent , "Expression", "value < 0 ? `` : value");
formatcontent = _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatContents") , "Add", "hidep","hide positive");
	_ObjectSetProperty( formatcontent , "Expression", "value > 0 ? `` : value");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[bold],sum(5)[content=hiden],sum(5)[content=hidep]");
_ObjectCallMethod( pivot , "EndUpdate");
62
How can I decode the Layout property

OBJECT createobject("exontrol.print"),pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12");
_ObjectSetProperty( pivot , "Layout", "Columns =1;C0.Width = 64");
createobject("exontrol.print") = CreateObject("Exontrol.Print");
	_ObjectCallMethod(pivot, "TemplatePut", "Dim creObj")
	_ObjectCallMethod(pivot, "TemplatePut", createobject("exontrol.print"))
	Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "creObj.Decode64TextW(Me.Layout)") );
_ObjectCallMethod( pivot , "EndUpdate");
61
How can I specify the sorting type, so the column gets sorted as numeric for instance

OBJECT column,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "1,1#11,11#101,101","eor='#' eof=',' hdr=0");
column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(0)");
	_ObjectSetProperty( column , "Caption", "Numeric");
	_ObjectSetProperty( column , "SortType", 1);
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(1).Caption = `String (default)`");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectCallMethod( pivot , "Refresh");
60
How can I disable the control's context menu
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotBarVisible", 3675);
59
How do I get the captions of the columns
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
Message( _ObjectGetProperty( _ObjectGetProperty( pivot , "DataColumns") , "Count") );
_ObjectCallMethod(pivot, "TemplatePut", "Dim _ObObj")
_ObjectCallMethod(pivot, "TemplatePut", _ObjectGetProperty( pivot , "DataColumns"))
Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "_ObObj.item(0).PivotCaption") );
Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "_ObObj.item(0).Caption") );
Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "_ObObj.item(1).PivotCaption") );
Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "_ObObj.item(1).Caption") );
58
How can I specify the default-format for a specified column, so it always shows as numeric for instance
OBJECT column,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(`Freight`)");
	_ObjectSetProperty( column , "DefaultFormatContent", "numeric");
	_ObjectSetProperty( column , "DefaultFormatAppearances", "bold");
	_ObjectSetProperty( column , "SortOrder", 1);
	_ObjectSetProperty( column , "SortType", 1);
_ObjectSetProperty( pivot , "PivotTotalDefaultFormatContent", "currency");
_ObjectSetProperty( pivot , "PivotTotalDefaultFormatAppearances", "strikeout,bold");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)[bold,content=numeric]");
_ObjectSetProperty( pivot , "PivotTotals", "sum[strikeout,bold,content=currency]");
_ObjectSetProperty( pivot , "PivotColumnsFloatBarVisible", -1);
_ObjectCallMethod( pivot , "Refresh");
57
How can I display the percentage column

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( pivot , "FormatContents") , "Add", "percent","value + `%`");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "5[content=percent]");
_ObjectCallMethod( pivot , "Refresh");
56
How do I change the name for months in the drop-down filter window (localization)

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "Description(17)") );
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(17) = `Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(0) = `(Toate)`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(1) = `(Gol)`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(2) = `(Plin)`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(3) = `Filtreaza:`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(16) = `Azi`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(18) = `D L Ma Mi J V S`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(25) = `Exclud`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(26) = `Coloane`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(11) = `si`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(12) = `Data:`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(15) = `Data`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(13) = `la`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(24) = `nu`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Description(23) = `sau`");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(`OrderDate`).SortType = 2");
_ObjectSetProperty( pivot , "PivotRows", "9");
_ObjectCallMethod( pivot , "Refresh");
55
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageHeight but infinite width etc
OBJECT createobject("exontrol.print"),pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "6");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/3");
_ObjectCallMethod( pivot , "Refresh");
createobject("exontrol.print") = CreateObject("Exontrol.Print");
	_ObjectSetProperty( createobject("exontrol.print") , "Options", "FitToPage = x 5");
	_ObjectSetProperty( createobject("exontrol.print") , "PrintExts", pivot);
	_ObjectCallMethod( createobject("exontrol.print") , "Preview");
54
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageWidth but infinite height etc
OBJECT createobject("exontrol.print"),pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "6");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/3");
_ObjectCallMethod( pivot , "Refresh");
createobject("exontrol.print") = CreateObject("Exontrol.Print");
	_ObjectSetProperty( createobject("exontrol.print") , "Options", "FitToPage = 5 x");
	_ObjectSetProperty( createobject("exontrol.print") , "PrintExts", pivot);
	_ObjectCallMethod( createobject("exontrol.print") , "Preview");
53
How can I get the column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
FUNCTION pivotEvents_MouseMove(OBJECT pivot, INT Button, INT Shift, INT X, INT Y)
	Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "ColumnFromPoint(-1,-1)") );
END

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
ObjectAssociateEvents("pivotEvents", pivot);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod( pivot , "Refresh");
52
How can I get the value from the cursor
// MouseMove event - Occurs when the user moves the mouse.
FUNCTION pivotEvents_MouseMove(OBJECT pivot, INT Button, INT Shift, INT X, INT Y)
	Message( _ObjectCallMethod(pivot, "ExecuteTemplate", "ValueFromPoint(-1,-1)") );
END

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
ObjectAssociateEvents("pivotEvents", pivot);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod( pivot , "Refresh");
51
How can I specify a column to display HTML format

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "Bold <b>1,Bold <b>2#Bold <b>3,Bold <b>4#Bold <b>5,Bold <b>6","eor='#' eof=',' hdr=0");
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(0).HTML = True");
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(1).HTML = True");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectCallMethod( pivot , "Refresh");
50
Does your control supports scrolling by touching the screen

OBJECT pivot,rs;

pivot =  ObjectByName("AN1") ;
rs = CreateObject("ADOR.Recordset");
	_ObjectCallMethod( rs , "Open", "Data","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb",3,3);
_ObjectSetProperty( pivot , "DataSource", rs);
_ObjectSetProperty( pivot , "AutoDrag", 4112);
49
How can I specify programatically the width of the pivot column ( first column )

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12");
_ObjectSetProperty( pivot , "Layout", "Columns =1;C0.Width = 64");
_ObjectCallMethod( pivot , "EndUpdate");
48
How can I show the total of each row, when columns are shown as expanded

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectSetProperty( pivot , "IncludeExpandColumn", 1);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12");
_ObjectCallMethod( pivot , "EndUpdate");
47
How can I prevent grouping by a specified column
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(`Freight`).AllowGroupBy = 0");
46
How can I sort alphabetically the columns to be displayed in the context menu/floating panel

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotBarVisible", 69595);
_ObjectSetProperty( pivot , "PivotColumnsSortOrder", 1);
_ObjectSetProperty( pivot , "PivotColumnsFloatBarVisible", -1);
45
How can I prevent dropping data to the control
OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectSetProperty( pivot , "AllowDrop", 0);
44
Is it possible to allow incremental filtering on drop down filter window too, as I can on the control menus

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
var_DisplayFilterList = _ObjectGetProperty( pivot , "DisplayFilterList");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "DisplayFilterList", 42272);
43
How can I prevent showing the Filter For field in the drop down filter window

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
var_DisplayFilterList = _ObjectGetProperty( pivot , "DisplayFilterList");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "DisplayFilterList", 42272);
42
How can I display the numeric columns only when selecting a new aggregate, like SUM

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0[bold]");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12,count(5)/12");
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(`Freight`).SortType = 1");
41
How can I add a value column

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12");
40
I would like to always have the subtotals in the same row of the "father row". Could that be done

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0[bold],2");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12,count(5)/12");
_ObjectSetProperty( pivot , "ShowViewCompact", 35);
_ObjectSetProperty( pivot , "PivotTotals", "/sum,sum(0)");
39
Is there any way, when I change the filter of the column, it broadcast the filter to the other pivot columns that were duplicated

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0,2");
_ObjectSetProperty( pivot , "ShowBranchRows", 2);
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZrMJnMoAgI='],count(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZ" +
	"rMJnMoAgI=']");
_ObjectSetProperty( pivot , "ShowViewCompact", 19);
38
How can I summarize more fields in the same cell

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0,2");
_ObjectSetProperty( pivot , "ShowBranchRows", 2);
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12,count(5)/12");
_ObjectSetProperty( pivot , "ShowViewCompact", 3);
37
How do I programmatically group by rows, in a compact way, no hierarchy lines

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0,2");
_ObjectSetProperty( pivot , "ShowBranchRows", 2);
36
How do I programmatically group by rows

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0,1,2");
_ObjectSetProperty( pivot , "LinesAtRoot", -1);
_ObjectSetProperty( pivot , "HasLines", 1);
35
How do I programmatically group by columns

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)/12;6");
34
How can I hide the add new button on the pivot bar

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotBarVisible", 8155);
33
Is it possible to show the data that generated the result, when double clicking the row

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0[italic]");
_ObjectSetProperty( pivot , "PivotColumns", "count(0)[underline]");
_ObjectSetProperty( pivot , "PivotTotals", "count[bold,strikeout]");
_ObjectSetProperty( pivot , "ShowDataOnDblClick", -1);
_ObjectCallMethod( pivot , "EndUpdate");
32
Does your control support subscript or superscript, in HTML captions

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectSetProperty( pivot , "HeaderHeight", 22);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(`ShipCountry`).Caption = `ShipCountry<font ;7><off 6><sha ;;0>subscript`");
_ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(`ShipRegion`).Caption = `ShipRegion<font ;7><off -6><sha ;;0>superscript`");
_ObjectCallMethod( pivot , "Refresh");
31
Is it possible to define a different background color for the pivot bar

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod(pivot, "ExecuteTemplate", "Background(97) = 15790320");
30
How can I display an icon/image to Content sub-menu

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod( pivot , "Images", "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
	"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
	"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatContents.item(`numeric`).Name = `<img>1</img> Numeric`");
_ObjectSetProperty( pivot , "PivotRows", "5[content=numeric]");
29
How can I change the selection background in the control's context menu

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "Background(20) = 255");
28
How can I display the column as date in a long format

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod( _ObjectGetProperty( pivot , "FormatContents") , "Add", "longdate","longdate(date(value))");
_ObjectSetProperty( pivot , "PivotRows", "9[content=longdate]");
27
Is it possible to display the column in upper-case

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod( _ObjectGetProperty( pivot , "FormatContents") , "Add", "upper","upper(value)");
_ObjectSetProperty( pivot , "PivotRows", "0[content=upper]");
26
How can I programatically bold a column

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0[bold]");
25
How can I display the total with a different foreground color

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatAppearances") , "Add", "fore") , "ForeColor", 255);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
_ObjectSetProperty( pivot , "PivotTotals", "sum[fore,bold]");
24
How can I display the total with a different background color/ebn 

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( pivot , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatAppearances") , "Add", "back") , "BackColor", 16777216);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
_ObjectSetProperty( pivot , "PivotTotals", "sum[back]");
23
How can I display the total with a solid background color

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatAppearances") , "Add", "back") , "BackColor", 15790320);
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
_ObjectSetProperty( pivot , "PivotTotals", "sum[back]");
22
Is it possible to change the "bold" caption in the control's context menu

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectCallMethod(pivot, "ExecuteTemplate", "FormatAppearances.item(`bold`).Name = `Ingrosat`");
21
Is it possible to show no Exclude field in the filter window

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "DisplayFilterList", 288);
20
How can I prevent showing the drop down filter button

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "DisplayFilterList", 2);
19
How do I get the count of positive values only

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( pivot , "Aggregates") , "Add", "positive","sum") , "FormatValue", "value < 0 ? 0 : 1");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "positive(5)");
18
How do I get the sum for negative values only

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( pivot , "Aggregates") , "Add", "negative","sum") , "FormatValue", "value < 0 ? value : 0");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "negative(5)");
17
My data stores the data as strings, is it possible to load the data using Import method

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "'string 1';'string 2'#'string 3';'string 4'","str=`'` eor='#' eof=';' hdr=0");
16
Is it possible to load data using different separators

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "item 1;item 2#item 3;item 4","eor='#' eof=';' hdr=0");
15
Is it possible to align a column

OBJECT column,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(0)");
	_ObjectSetProperty( column , "Alignment", 2);
	_ObjectSetProperty( column , "HeaderAlignment", 2);
_ObjectCallMethod( pivot , "Refresh");
14
How can I change by code the column/rows background color

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( _ObjectGetProperty( pivot , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( pivot , "FormatAppearances") , "Add", "aka") , "BackColor", 16777216);
_ObjectSetProperty( pivot , "PivotRows", "0[aka]");
_ObjectCallMethod( pivot , "EndUpdate");
13
How can I apply by code any appearance to my list

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0[italic]");
_ObjectSetProperty( pivot , "PivotColumns", "count(0)[underline]");
_ObjectSetProperty( pivot , "PivotTotals", "count[bold,strikeout]");
_ObjectCallMethod( pivot , "EndUpdate");
12
How can I display an icon instead SUM/Total field

OBJECT aggregate,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Images", "gBJJgBggAAwAAgACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjIgjIBAEijUlk8plUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
	"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9oEEwGBwWDwmFw2Hw9+xUsxGNx2Px+LyUnyGVy2VyeZAGNjIJjITjIb0OjjGi0ukAAV" +
	"jILzmayWtAGejCvjLh2u3jG23O4ACx1ew11+zEYGsZZsZUe/wkZ4sYZvD4PCy8kjAzjLFjKd5WDjIz6HRvnTwUZGMZX8ZTPb8XU8Hh9cFjALjKVjK5jIv9/w9t78WdjJ" +
	"IoyWr7sKjIWu+/a8Og2QAEajLaIxAzlwhB0DwQuzoECjJWw1DiMQ3D0OgAQMKwsuj8xOy0SrzFEWMdFUExbGMCRfC8ZRswMaLsiofJVHiOo+kKRs2lL2Jsh8cyQo6Ag=" +
	"=");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
aggregate = _ObjectCallMethod(pivot, "ExecuteTemplate", "Aggregates.item(`sum`)");
	_ObjectSetProperty( aggregate , "Name", "<img>1</img> Sum");
	_ObjectSetProperty( aggregate , "Caption", "<img>1</img>");
_ObjectSetProperty( pivot , "PivotColumnsFloatBarVisible", -1);
_ObjectSetProperty( pivot , "FormatPivotHeader", "iaggregate ? (caggregate + (iaggregate != 5 ? ' ' : '') + caption) : caption");
_ObjectSetProperty( pivot , "FormatPivotTotal", "caggregate");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
_ObjectSetProperty( pivot , "PivotTotals", "sum,count");
_ObjectCallMethod( pivot , "EndUpdate");
11
How can I change the caption to be displayed when dragging an aggregate function

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotColumnsFloatBarVisible", -1);
_ObjectSetProperty( pivot , "FormatPivotHeader", "(iaggregate ? ('<b>' + upper(caggregate) + '</b> of ' + caption) : caption)");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
_ObjectSetProperty( pivot , "PivotTotals", "sum,count");
_ObjectCallMethod( pivot , "EndUpdate");
10
I am using Import method, just wondering if I can rename the columns

OBJECT column,pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
column = _ObjectCallMethod(pivot, "ExecuteTemplate", "DataColumns.item(0)");
	_ObjectSetProperty( column , "Caption", "New Caption");
	_ObjectSetProperty( column , "PivotCaption", "New Pivot Caption");
_ObjectCallMethod( pivot , "Refresh");
9
Does your control support Fit-To-Page Print and Print Preview

OBJECT createobject("exontrol.print"),pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0,1,2");
_ObjectCallMethod( pivot , "ExpandAll");
createobject("exontrol.print") = CreateObject("Exontrol.Print");
	_ObjectSetProperty( createobject("exontrol.print") , "Options", "FitToPage = On");
	_ObjectSetProperty( createobject("exontrol.print") , "PrintExts", pivot);
	_ObjectCallMethod( createobject("exontrol.print") , "Preview");
8
How can I print the control

OBJECT createobject("exontrol.print"),pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0,1,2");
_ObjectCallMethod( pivot , "ExpandAll");
createobject("exontrol.print") = CreateObject("Exontrol.Print");
	_ObjectSetProperty( createobject("exontrol.print") , "PrintExts", pivot);
	_ObjectCallMethod( createobject("exontrol.print") , "Preview");
7
How can I hide the pivot bar (hide completly)

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectSetProperty( pivot , "PivotBarVisible", 4058);
6
How can I hide the pivot bar (auto-hide)

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectSetProperty( pivot , "PivotBarVisible", 4083);
5
How can I count and get the total of a specified column

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "BeginUpdate");
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotColumnsFloatBarVisible", -1);
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumns", "sum(5)");
_ObjectSetProperty( pivot , "PivotTotals", "sum,count");
_ObjectCallMethod( pivot , "EndUpdate");
4
How can I add show the columns once I grouped a column

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0");
_ObjectSetProperty( pivot , "PivotColumnsFloatBarVisible", -1);
3
How can I programatically group the columns

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");
_ObjectSetProperty( pivot , "PivotRows", "0:D");
2
Is it possible to load data from a data source

OBJECT pivot,rs;

pivot =  ObjectByName("AN1") ;
rs = CreateObject("ADOR.Recordset");
	_ObjectCallMethod( rs , "Open", "Data","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb",3,3);
_ObjectSetProperty( pivot , "DataSource", rs);
1
How can I load data

OBJECT pivot;

pivot =  ObjectByName("AN1") ;
_ObjectCallMethod( pivot , "Import", "C:\Program Files\Exontrol\ExPivot\Sample\data.txt");